Add database indexes for common property search filters

[nanaf6203-bit]

Improve property search performance with indexes.

Acceptance Criteria:

• Common search fields are indexed via migration.
• Query performance improves for sample searches.
• Index usage is verified via query explain plans.
• Tests confirm index-backed search behavior.

[RaymondAbiola]

@RaymondAbiola has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi, I’d like to work on this issue. I have experience with rust, Solidity, frontend, and backend development, and I’m confident I can deliver a clean solution.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @RaymondAbiola to this issue.

[Johnjnr1]

@Johnjnr1 has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi, I'd like to work on this issue! because I am very conversant with solving problems like this!

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Johnjnr1 to this issue.

[code-0-stella]

@code-0-stella has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi,

I would like to work on this issue and deliver a clean, tested solution that meets the acceptance criteria.

Please assign me.

Thank you.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @code-0-stella to this issue.

[ummarig]

@ummarig has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

As a full stack developer with years of experience assigning this task to me will amount to the job done

ℹ️ Repo Maintainers: To accept this application, review their application or assign @ummarig to this issue.

[drips-wave]

Congratulations, @ummarig! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 2, 2026.

🧑‍💻 @ummarig: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊