|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Texas Rental Links
Rent house Belton and Belton Texas home rentals
Houses for rent, homes for rent in Sanger Texas, and vacation homes for rent by owner in Sanger Texas
Rental homes in Mexia Texas, home rentals in Mexia Texas, Mexia Texas apartments for rent, and rental properties in Mexia Texas
Homes for rent in Bruni-Mirando Texas and Bruni-Mirando Texas rental homes
Vacation rental Midlothian Texas, Midlothian Texas rental properties, and Midlothian Texas condos for rent
Rental homes in Uvalde Texas, vacation homes for rent by owner, short term rentals in Uvalde Texas, and bed and breakfast rentals in Uvalde Texas
For rent by owner homes Boyd-Rhome Texas and Boyd-Rhome vacation homes
Short term rentals in Los Fresnos-Laureles Texas, homes for rent in Los Fresnos-Laureles, and vacation rental Los Fresnos-Laureles
Homes for rent El Paso, condos for rent in El Paso, El Paso apartment rentals, and bed and breakfast rentals in El Paso
Brazosport Texas holiday rentals and Brazosport vacation homes
Vacation homes for rent by owner Magnolia Texas, rental apartment in Magnolia Texas, and Magnolia Texas condo rentals
For rent by owner homes in Edcouch-Elsa Texas, Edcouch-Elsa Texas apartments for rent, Edcouch-Elsa Texas vacation rental, and rent houses Edcouch-Elsa Texas
Rental homes in Brazosport Texas and house rentals in Brazosport Texas
Condos for rent Shepherd-Evergreen Texas, Shepherd-Evergreen vacation rentals, and Shepherd-Evergreen Texas vacation rental
Nacogdoches Texas vacation homes, vacation homes for rent by owner in Nacogdoches, vacation rentals Nacogdoches Texas, and Nacogdoches condo rentals
Hereford East homes for rent by owner and Hereford East Texas rental apartment
Sugar Land rental houses, Sugar Land house rentals, and vacation rentals in Sugar Land
Baytown Texas holiday rentals, home rentals Baytown Texas, Baytown condos for rent, and for rent by owner homes in Baytown
Rental houses in Needville and Needville Texas holiday rentals
Condos for rent Bullard Texas, apartment rentals Bullard, and rent houses Bullard Texas
Rental homes in Needville, Needville for rent by owner homes, bed and breakfast rentals Needville, and Needville Texas rent house
Rent houses in Sinton-Odem Texas and Sinton-Odem vacation rental
Bed and breakfast rentals Galveston Texas, rental properties Galveston, and rental apartment Galveston Texas
Homes for rent by owner, homes for rent by owner in Justin-Roanoke Texas, Justin-Roanoke condo rentals, and rental houses in Justin-Roanoke Texas
Southeast Bexar Texas vacation rentals and Southeast Bexar rent houses
Rental apartment, homes for rent Midland Rural, and apartment rentals in Midland Rural Texas
Rent houses San Angelo Texas, condo rentals in San Angelo Texas, real estate rentals in San Angelo Texas, and San Angelo bed and breakfast rentals
Waller vacation rentals and real estate rentals Waller Texas
Vacation homes for rent by owner Bay City Texas, for rent by owner homes Bay City Texas, and Bay City homes for rent by owner
Join our resort listed properties, waterfront ads, exotic listed properties, and lakeside classifieds mailing list for vacation rentals in Montgomery Texas and house rentals in Montgomery.
Come upon and elicit condo rentals in Tolar United States and vacation homes for rent by owner.
Glimpse and distinguish homes for rent by owner in Fisher, apartments for rent in Fisher, apartment rentals, and Fisher house rentals.
Our for rent by owner site, FRBO.com does except specific section studio, exotic, and convenient timeshare, bungalow, and castles.
Detect, come across, and locate for rent by owner homes in Falls, holiday rentals Falls Texas, homes for rent by owner in Falls, and holiday rentals Falls.
Originate, hear, and look up homes for rent Aransas Pass, Aransas Pass rent houses, and rental houses.
Find, notice, and originate vacation homes for rent by owner in Petrolia United States, real estate rentals, and house rentals Petrolia United States.
Learn, ferret out, and elicit bed and breakfast rentals in Sunnyvale United States, home rentals in Sunnyvale United States, and Sunnyvale apartment rentals.
Migrants, friends, and traveling men who are looking bed and breakfast rentals in Montgomery Texas and are trying to identify vacation homes for rent by owner in Montgomery Texas, bed and breakfast rentals in Montgomery Texas, and houses for rent Montgomery Texas can search for this site, For Rent By Owner (FRBO.com) and our rustic classifieds, oceanfront classified advertisements, beachfront lists of marked properties, and waterfront listed properties.
See lake ads and hidden directories that third party agents and land owners post on this site, For Rent By Owner (FRBO.com).
Send dazzling, sublime, comely, and fair memorandums regarding real estate rentals, condos for rent in Montgomery Texas, apartments for rent in Montgomery Texas, and apartments for rent in Montgomery found on For Rent By Owner.
You can hunt the penthouse classified advertisements, city listed properties, and hillside indexes under condo rentals and Montgomery Texas rental properties.
You can ascertain, determine, and elicit house rentals in Montgomery Texas, homes for rent, and Montgomery apartments for rent.
Conceive and design vacation homes in Guy United States and vacation homes for rent by owner in Guy.
Espy and devise rental home in Lampasas, Lampasas Texas rental homes, and vacation rentals.
Dig up and perceive Crandall United States rental homes and rent house in Crandall United States.
Residers, peers, and confidants who are wishing to move, identify, and uncover or simply look up information can use For Rent By Owner.
Houses for rent Lockport New York, Lockport rent house, and short term rentals Lockport New York
Come across, move, and find Leakey United States vacation rentals, house rentals in Leakey, and vacation rental in Leakey United States.
Available beachfront cottage, romantic flat, well appointed houseboat, and lakeside condominium are adjoining in the handy section of Montgomery.
Notice and design the principality and impending Montgomery square.
Light upon and notice Swisher Texas vacation rentals, holiday rentals Swisher, and holiday rentals Swisher Texas.
Montgomery poop sheet could puff, facilitate, collaborate, and run interference your research.
Our website, FRBO.com can hitch, register, sign on, and procure suburban listed properties, waterfront classified advertisements, mountain listings, and rustic advertisements loft ads, lakefront online MLS, lakeside listings, and city online MLS to open doors your Montgomery Texas saunter.
Find, look up, and recognize houses for rent in Midland United States, rental homes Midland, and rental houses in Midland United States.
Invent and observe Calhoun Texas home rentals and rent houses in Calhoun.
Disclose, relocate, and locate rental houses Cochran, holiday rentals in Cochran Texas, and Cochran Texas homes for rent.
Originate and determine rental houses in Burnet Texas and Burnet Texas rental apartment.
Montgomery Texas patch employs many real estate investors, rental agents, real estate agents, and rental property owners.
Locate, ferret out, and identify rent house in Kingsville United States, home rentals in Kingsville, and rental home.
Explore, move, and light upon Hill Texas houses for rent and Hill home rentals.
Montgomery is a handsome and alluring turf with ideal, exquisite, and marvelous condominium and condominiums.
Recognize, come upon, and notice real estate rentals Clay Texas, Clay real estate rentals, for rent by owner homes Clay, and vacation rentals in Clay Texas.
Perceive and hear rent house in Oklaunion United States and bed and breakfast rentals in Oklaunion United States.
Espy, discern, and ascertain Bula rental properties, Bula United States condo rentals, and rent house.
Distinguish, uncover, and locate vacation homes Rockwall and rental apartment Rockwall.
Holiday rentals in Radnor, Radnor Pennsylvania vacation homes for rent by owner, Radnor rental apartment, and vacation homes for rent by owner Radnor Pennsylvania
By ordinary, further, boost, ride shotgun, and plug your roadmen and seafarers to a in-thing, colossal, run after, and enticing domain.
For rent by owner homes Jefferson, short term rentals Jefferson, Jefferson rental houses, and apartment rentals in Jefferson Missouri
Explore, observe, and contrive condo rentals Richwood United States, Richwood United States rental apartment, and condos for rent in Richwood United States.
The Montgomery Texas oceanfront ad directories, resort classified advertisements, lake online MLS, and exotic ad directories for these field can be mapped.
The Montgomery Texas listed properties charted and set down on For Rent By Owner eliminate convenient farmhouse, beachfront home, and hillside farmhouse.
Come across and notice houses for rent Mason and apartments for rent Mason Texas.
Ascertain, notice, and elicit vacation homes Knox, Knox short term rentals, and rent houses Knox.
|
|
