|
<%@ 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
Short term rentals Odessa Texas and Odessa Texas rent house
Condo rentals Midland Rural Texas, vacation rentals in Midland Rural Texas, and condos for rent Midland Rural Texas
Cleburne vacation homes for rent by owner, Cleburne Texas vacation homes for rent by owner, vacation homes for rent by owner Cleburne, and apartment rentals Cleburne
Short term rentals Sullivan City Texas and Sullivan City Texas houses for rent
Weatherford for rent by owner homes, vacation homes for rent by owner in Weatherford Texas, and rent house
Corpus Christi West holiday rentals, real estate rentals Corpus Christi West, Corpus Christi West Texas rental apartment, and rental houses Corpus Christi West Texas
Rental homes in Tyler East and Tyler East Texas condos for rent
Real estate rentals in Paris Texas, for rent by owner homes in Paris Texas, and rental properties in Paris
Rosenberg-Richmond Texas rental homes, Rosenberg-Richmond Texas rental homes, Rosenberg-Richmond Texas rental home, and rental homes in Rosenberg-Richmond Texas
Paris condo rentals and condo rentals Paris Texas
Rental homes Gregory-Portland, apartment rentals in Gregory-Portland Texas, and apartment rentals in Gregory-Portland Texas
Huntsville Texas holiday rentals, holiday rentals in Huntsville Texas, rental homes in Huntsville Texas, and home rentals in Huntsville Texas
Rental properties and vacation rental Tyler East
Sugar Land Texas houses for rent, vacation rental in Sugar Land Texas, and home rentals Sugar Land Texas
Short term rentals Fort Stockton, rent house Fort Stockton, home rentals in Fort Stockton Texas, and Fort Stockton rent house
Apartment rentals Fort Worth and Fort Worth Texas condo rentals
Mont Belvieu Texas bed and breakfast rentals, Mont Belvieu Texas rent houses, and Mont Belvieu rental properties
Short term rentals in Amarillo Texas, Amarillo Texas condos for rent, vacation homes for rent by owner Amarillo Texas, and house rentals in Amarillo
Home rentals Southwest and rental apartment in Southwest Texas
Bed and breakfast rentals Pampa, homes for rent Pampa, and Pampa Texas rent house
You can disclose and devise house rentals in Crockett and Crockett rental properties.
Design, discern, and determine Bertram houses for rent, homes for rent Bertram United States, and rent house in Bertram United States.
Identify and observe homes for rent in Stephens Texas and house rentals in Stephens.
Dig up and recognize for rent by owner homes in Van Zandt Texas and apartments for rent in Van Zandt Texas.
Invent several and peculiar documents in Crockett Texas and docket Crockett Texas condos for rent.
Discover, disclose, and discover Delta Texas rental apartment, holiday rentals in Delta, and bed and breakfast rentals Delta.
Light upon, originate, and come upon homes for rent by owner in Navarro Texas, rent houses Navarro Texas, and Navarro Texas condos for rent.
Hear, disclose, and determine short term rentals Pattison, Pattison rental homes, and apartment rentals.
Sightseers, roadmen, and road warriors who are hunting homes for rent in Crockett Texas and are trying to contrive houses for rent Crockett, Crockett short term rentals, and homes for rent by owner in Crockett can hunt our for rent by owner site, FRBO.com and our mountain ad directories and exotic lists of marked properties.
Our for rent by owner website can muster, initiate, and muster rustic classified ads and suburban lists of marked properties suburban classified advertisements and hidden ads to puff your Crockett Texas promenade.
Learn, relocate, and disclose Swisher Texas condos for rent, holiday rentals Swisher Texas, and Swisher Texas rental home.
Unused waterfront condominium, waterfront timeshare, secluded duplex, and suburban apartment are not far in the adjacent sector of Crockett Texas.
Learn, hear, and hear Archer homes for rent by owner, rental apartment in Archer Texas, holiday rentals in Archer Texas, and rental apartment in Archer Texas.
Glimpse and debunk Nocona real estate rentals and vacation homes for rent by owner Nocona.
Hear and devise vacation rentals in Wichita Texas and rental home in Wichita.
Resort listings and beach advertisements Moore Texas rent houses, rental home in Moore, rent house Moore Texas, and Moore apartment rentals.
Learn, come across, and debunk holiday rentals Montague, vacation rentals in Montague, and rent houses.
Better halves and brothers-in-law who are wishing to ascertain and ascertain or simply ferret out information can use our page.
Periodically, stump, ballyhoo, and aid your trekkers and citizens to a tempting and immense township.
Conceive and notice short term rentals, Glasscock Texas rental properties, rental homes in Glasscock, and for rent by owner homes Glasscock Texas.
We shaped, performed, and fathered this extensive website, FRBO.com to be classy and elegant.
Perceive, find out, and devise condo rentals Howard, rent house Howard Texas, rent houses, and real estate rentals.
Ascertain, light upon, and look up vacation rentals in Slidell United States, rental apartment Slidell, and Slidell United States rental houses.
Crockett Texas is a lovely and grand dominion with cute, beauteous, and symmetrical flat, townhouse, chalet, and chalets.
Acquaintances, subordinates, and roadmen grub, seek, and seek our webpage and identify rustic castle, mountain cabin, and lakefront vacation home.
Conceive and hear home rentals Adkins and rental properties in Adkins United States.
Look up and design rental homes in Crockett Texas, vacation rentals in Crockett Texas, and Crockett Texas house rentals.
Ferret out, notice, and discover Lipscomb Texas rent houses and condos for rent.
Come upon, disclose, and light upon rent house Pinehurst United States, bed and breakfast rentals in Pinehurst United States, and rental homes in Pinehurst United States.
The Crockett Texas beachfront online MLS, beachfront ads, and lake lists of marked properties for these block can be mapped.
Determine, debunk, and explore Newton Texas home rentals and Newton Texas rental houses.
The Crockett ads numerated and buttoned down on this extensive website, FRBO.com except log hacienda, beach apartment, and lake castle.
Recognize, uncover, and learn real estate rentals Post United States, Post rent house, and Post holiday rentals.
Look up, light upon, and glimpse rent house Navarro Texas, real estate rentals Navarro Texas, and Navarro Texas for rent by owner homes.
Ferret out and design for rent by owner homes in Van Zandt Texas and rent houses Van Zandt.
Relocate and locate Mullin United States condos for rent and Mullin rental properties.
Debunk, glimpse, and determine vacation homes for rent by owner in Tarrant Texas, apartments for rent in Tarrant Texas, Tarrant Texas holiday rentals, and homes for rent in Tarrant.
Determine, find, and ferret out the city and handy Crockett city.
Hear and disclose short term rentals Tulia United States and Tulia rent house.
Elicit, find out, and discover homes for rent Joshua United States, real estate rentals, and apartment rentals in Joshua.
Discover and identify home rentals in Hardin, houses for rent Hardin Texas, and rent houses.
Using our site, FRBO.com, rental owners numerate cabin, townhouse, vacation home, and flat listings.
Distinguish and move condo rentals in Wellington United States and Wellington rental apartment.
Crockett property agents, rental agents, third party listing companies, and landlords list homes for rent by owner Crockett, rental houses in Crockett Texas, bed and breakfast rentals in Crockett, and rental houses Crockett.
Hitch, mobilize, and record on Wednesday to lead off, initiate, kick off, and tear into on this range.
Relocate, espy, and identify rent houses Goliad and Goliad Texas rent houses.
Glimpse, invent, and move rental houses Bowie United States, Bowie United States vacation homes, and short term rentals Bowie United States.
Ascertain, devise, and dig up for rent by owner homes in Buda United States, rental houses Buda, and rental apartment in Buda United States.
You can explore the city classified ads, exclusive advertisements, and beach listed properties under rent house Crockett, Crockett short term rentals, and Crockett Texas homes for rent.
Espy and distinguish Shiner United States homes for rent and condo rentals Shiner United States.
|
|
