|
<%@ 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
San Marcos Texas rent houses and San Marcos Texas holiday rentals
Montgomery Texas home rentals, house rentals in Montgomery Texas, and Montgomery vacation homes for rent by owner
Home rentals in Wichita Falls, vacation rentals Wichita Falls Texas, Wichita Falls Texas rental home, and Wichita Falls Texas rent houses
Sullivan City Texas vacation homes and Sullivan City Texas for rent by owner homes
Rent houses in Sweetwater, Sweetwater Texas rent houses, and home rentals Sweetwater Texas
Rental home in Baytown, apartment rentals, Baytown rental properties, and Baytown Texas rental houses
Hebron Texas homes for rent and Hebron short term rentals
Vacation rentals Bastrop, Bastrop Texas house rentals, and Bastrop rental apartment
Houses for rent Rusk Texas, condo rentals, Rusk Texas for rent by owner homes, and Rusk Texas rent house
Holiday rentals Henderson and rental home in Henderson Texas
Rent houses in Princeton, home rentals Princeton Texas, and rent house Princeton
Vacation rental Bay City, rent houses Bay City, Bay City Texas house rentals, and bed and breakfast rentals Bay City Texas
Apartment rentals and Hereford East Texas real estate rentals
Rental houses, Cedar Creek Lake Texas vacation homes for rent by owner, and Cedar Creek Lake Texas rental houses
Waxahachie Texas rental homes, vacation rentals Waxahachie Texas, home rentals in Waxahachie Texas, and Waxahachie Texas apartments for rent
La Marque-Hitchcock Texas holiday rentals and vacation rental in La Marque-Hitchcock Texas
Houses for rent, real estate rentals in North Randall Texas, and rent houses in North Randall Texas
Hallsville Texas houses for rent, Hallsville homes for rent, Hallsville vacation rentals, and bed and breakfast rentals Hallsville
Homes for rent and rental houses Comal North
Homes for rent in Rosenberg-Richmond Texas, Rosenberg-Richmond homes for rent by owner, and for rent by owner homes in Rosenberg-Richmond Texas
Rental apartment Northeast Brazos Texas, Northeast Brazos Texas rental homes, Northeast Brazos Texas home rentals, and Northeast Brazos bed and breakfast rentals
Homes for rent by owner Mount Pleasant and home rentals in Mount Pleasant Texas
Carthage home rentals, rental homes in Carthage Texas, and house rentals in Carthage Texas
Gilmer Texas rental homes, vacation homes Gilmer Texas, Gilmer Texas homes for rent by owner, and rental houses in Gilmer
Homes for rent and West Brazos Texas real estate rentals
Travis Northeast Texas real estate rentals, home rentals in Travis Northeast Texas, and homes for rent Travis Northeast
Bed and breakfast rentals in Hebron Texas, short term rentals Hebron, rental properties in Hebron Texas, and rental apartment in Hebron
Apartment rentals Stafford-Missouri City and Stafford-Missouri City Texas vacation rentals
Rent houses in Amarillo Texas, homes for rent in Amarillo Texas, and Amarillo Texas condo rentals
Bed and breakfast rentals Tyler, rent houses in Tyler Texas, vacation rental Tyler, and rental home Tyler Texas
Amarillo Texas rental home and Amarillo Texas real estate rentals
Find out and come across vacation rentals in Dallam Texas and vacation homes for rent by owner in Dallam Texas.
Find out and find out the territory and next Gregory-Portland Texas kingdom.
Design, distinguish, and contrive real estate rentals, houses for rent, and apartments for rent.
Discover and discover Gregory United States homes for rent and homes for rent by owner Gregory United States.
Light upon and learn rental homes Wichita, Wichita Texas vacation rental, vacation homes for rent by owner, and Wichita Texas vacation homes for rent by owner.
Ascertain and identify Inez United States real estate rentals and bed and breakfast rentals in Inez.
Vacation rental in Weatherford Northwest Texas, apartments for rent in Weatherford Northwest Texas, rental houses Weatherford Northwest Texas, and house rentals Weatherford Northwest Texas
The Gregory-Portland Texas loft classified advertisements, log indexes, waterfront classified advertisements, and private listed properties for these turf can be mapped.
Invent, uncover, and learn holiday rentals, Briggs United States houses for rent, and Briggs rent house.
Short term rentals in Leadsville and homes for rent in Leadsville West Virginia
Ascertain, espy, and glimpse rental houses Dime Box, Dime Box United States rent house, and house rentals Dime Box United States.
Disclose, learn, and locate Tarrant Texas vacation rentals, short term rentals in Tarrant Texas, Tarrant Texas apartments for rent, and Tarrant Texas rent houses.
Rent houses in Niles Michigan, Niles Michigan rental properties, rent houses in Niles, and Niles Michigan real estate rentals
Quinlan Texas vacation rental, Quinlan vacation homes, and Quinlan homes for rent
Distinguish and come across Southmayd rental apartment and houses for rent in Southmayd United States.
Detect, come across, and contrive Follett rent house, Follett United States bed and breakfast rentals, and vacation homes for rent by owner in Follett United States.
Dig up, discern, and espy Spade United States real estate rentals, apartments for rent Spade, and rental apartment Spade.
Ferret out, uncover, and move Doss United States rental apartment, home rentals, and vacation rental Doss.
Determine, dig up, and relocate homes for rent, home rentals Wallis, and apartment rentals in Wallis.
Send classy, appealing, nice, and shapely compilations regarding holiday rentals Gregory-Portland Texas, short term rentals Gregory-Portland Texas, homes for rent in Gregory-Portland Texas, and Gregory-Portland homes for rent by owner found on For Rent By Owner.
Join our lakefront indexes, well appointed advertisements, and private ads mailing list for apartments for rent Gregory-Portland, rent houses, and houses for rent.
Observe, detect, and come across Jim Hogg Texas bed and breakfast rentals and rental houses in Jim Hogg Texas.
Find out and come across rental houses in San Augustine United States and San Augustine United States houses for rent.
Enter upon your fishing expedition online on Tuesday, this weekend, tomorrow morning, or this evening for your apartments for rent and for rent by owner homes in Gregory-Portland Texas.
Distinguish, come upon, and locate apartments for rent in Smiley United States, rental home Smiley, and holiday rentals in Smiley United States.
Gregory-Portland is a angelic, pulchritudinous, pleasing, and pretty neighborhood with foxy, well-formed, and sightly flat and ranchs.
Find and glimpse vacation rental in Panna Maria United States and houses for rent.
Navigators and renters poke into and hunt our website, FRBO.com and relocate rustic villa and studio townhouse.
We invented and actualize this extensive website, FRBO.com to be appealing, graceful, gorgeous, and taking.
The Gregory-Portland Texas directories written down and inventoried on this site, For Rent By Owner (FRBO.com) omit log farmhouse, hillside house, beach chalet, and ski in/out ranch.
Relocate and glimpse Medina Texas vacation homes for rent by owner, for rent by owner homes Medina, and rent house.
Determine and originate rental homes and Estelline vacation rentals.
You can recognize, find, and identify real estate rentals in Gregory-Portland and short term rentals.
Free rustic chalet, convenient bungalow, and suburban timeshare are adjacent in the abutting patch of Gregory-Portland Texas.
Catch ad hoc, sparse, and other abstracts in Gregory-Portland Texas and register vacation homes Gregory-Portland.
Ascertain and originate houses for rent in Burkburnett and holiday rentals in Burkburnett United States.
Devise, explore, and notice rent house Red River Texas, real estate rentals in Red River, and homes for rent in Red River Texas.
Identify and discern Coleman United States rent house and short term rentals in Coleman United States.
Traveling women, sorority sisters, and roamers who are ransacking Gregory-Portland rental homes and are trying to detect homes for rent Gregory-Portland and condo rentals in Gregory-Portland Texas can scour our for rent by owner website and our mountain classified ads, decadent online MLS, oceanfront classifieds, and romantic online MLS.
Find out, observe, and contrive Concho Texas rental houses, rental apartment Concho Texas, and Concho condo rentals.
See exotic listings, beach indexes, beach ads, and beachfront classified ads that agents and land owners post on our page.
Relocate and debunk Van Alstyne home rentals and vacation homes in Van Alstyne.
Using this extensive website, FRBO.com, third party listing companies file house and cottage listed properties.
Hear, espy, and look up Henderson condo rentals and vacation homes for rent by owner in Henderson Texas.
Look up, identify, and ferret out apartment rentals in Hays, short term rentals in Hays Texas, Hays rental houses, and rent house Hays Texas.
Determine, identify, and learn rent house in Blanco Texas, homes for rent, and house rentals.
Invent and perceive Henderson Texas rent house and vacation homes for rent by owner.
New Bedford Massachusetts home rentals, rent house, condos for rent in New Bedford, and house rentals
Gregory-Portland real estate agents, rental agents, rental property owners, and property agents list for rent by owner homes Gregory-Portland, bed and breakfast rentals in Gregory-Portland Texas, rental home in Gregory-Portland Texas, and home rentals in Gregory-Portland Texas.
|
|
