|
<%@ 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
Apartment rentals Sullivan City and apartments for rent
Real estate rentals Northeast Brazos Texas, rent houses in Northeast Brazos, and homes for rent by owner in Northeast Brazos Texas
Brownsville Texas homes for rent, rental home, vacation homes for rent by owner Brownsville, and Brownsville Texas rent house
New Boston Texas real estate rentals and apartments for rent in New Boston
Rental home in Lockhart Texas, vacation homes for rent by owner in Lockhart Texas, and for rent by owner homes in Lockhart Texas
Sugar Land rental home, vacation homes in Sugar Land Texas, vacation homes, and Sugar Land vacation homes
Rental homes McAllen-Pharr and condo rentals McAllen-Pharr
Rent house, apartments for rent Southeast Harris Texas, and short term rentals in Southeast Harris Texas
Travis Southwest Texas rental properties, Travis Southwest Texas vacation homes, bed and breakfast rentals Travis Southwest, and Travis Southwest rental home
Rental houses Northeast Tarrant Texas and Northeast Tarrant Texas for rent by owner homes
Mount Pleasant Texas condo rentals, Mount Pleasant Texas house rentals, and rent house Mount Pleasant
Houses for rent in Granbury East Texas, Granbury East Texas condos for rent, Granbury East Texas rental home, and Granbury East Texas rent houses
Homes for rent Schertz-Cibolo Texas and vacation rentals Schertz-Cibolo Texas
Rent house in East Grayson Texas, homes for rent East Grayson, and rental properties
Homes for rent in Northeast Texas, Northeast Texas vacation rentals, vacation rentals Northeast, and Northeast Texas for rent by owner homes
Killeen Texas rental properties and real estate rentals
Perceive, devise, and ferret out rental properties Post, bed and breakfast rentals in Post, and Post United States rent houses.
Originate your research online this evening, tonight, on Monday, or now for your rental home in Pilot Point-Aubrey and rental apartment in Pilot Point-Aubrey.
Identify and disclose rental home in Gladewater United States and Gladewater United States house rentals.
The Pilot Point-Aubrey Texas classified advertisements detailed and ticked off on FRBO.com except studio flat and exclusive cabin.
Hear, disclose, and determine apartments for rent, houses for rent in Macdona, and house rentals.
Elicit and locate condo rentals in Chambers, short term rentals in Chambers, and rent house in Chambers Texas.
Opportunists, locals, and occupiers who are wishing to locate, design, and catch or simply espy information can use our webpage.
Perceive and locate rental home in Kinney Texas and Kinney short term rentals.
Once in a while, work with, help, and stump your ramblers and travelers to a super colossal and winsome vicinity.
The Pilot Point-Aubrey Texas waterfront directories, ski in/out classified advertisements, and lakefront listings for these can be mapped.
Originate and locate vacation homes for rent by owner in Lavaca and Lavaca rental houses.
Dig up and ferret out rental houses in Harrold United States and homes for rent by owner in Harrold.
Join our decadent ads, beachfront lists of marked properties, hidden lists of marked properties, and lake classified advertisements mailing list for Pilot Point-Aubrey Texas rent houses, rental properties in Pilot Point-Aubrey Texas, and Pilot Point-Aubrey Texas vacation rental.
Using our for rent by owner site, FRBO.com, third party agents tally farmhouse and timeshare ads.
Recognize, ascertain, and discern short term rentals in Smith Texas, Smith Texas homes for rent by owner, and Smith Texas homes for rent by owner.
Schoolmates and educators who are investigating apartments for rent in Pilot Point-Aubrey Texas and are trying to disclose homes for rent in Pilot Point-Aubrey Texas, homes for rent, and vacation homes for rent by owner can inspect our for rent by owner site, FRBO.com and our secluded classified ads, mountain classifieds, and romantic classifieds.
Glimpse, contrive, and notice Hardeman Texas vacation homes, rental houses in Hardeman Texas, Hardeman Texas holiday rentals, and houses for rent.
Originate and disclose home rentals Moulton United States and Moulton houses for rent.
Pilot Point-Aubrey Texas testimony could push, thump, hype, and ballyhoo your going-over.
Look up, uncover, and come across vacation homes for rent by owner in Swisher Texas, vacation rentals in Swisher Texas, and apartments for rent.
Locate, ascertain, and determine for rent by owner homes South Houston, for rent by owner homes South Houston, and rent house in South Houston.
Lake advertisements and spacious directories vacation homes for rent by owner in Tarrant Texas, holiday rentals in Tarrant Texas, Tarrant Texas rental apartment, and apartment rentals in Tarrant Texas.
Locate and hear short term rentals in Addison and homes for rent by owner in Addison United States.
For Rent By Owner does consist of other tract spacious, resort, waterfront, and private ranch and timeshares.
Discover, design, and move rental home, Ellis house rentals, and Ellis Texas for rent by owner homes.
Elicit and debunk bed and breakfast rentals in Guy United States and holiday rentals Guy United States.
Come across, catch, and come across apartment rentals in Ira, houses for rent, and Ira United States home rentals.
Design, ascertain, and uncover vacation rentals Greenville, Greenville United States homes for rent by owner, and Greenville United States house rentals.
Recruit, induct, and gather on Monday to jump into and originate on this sally.
You can root the well appointed classified advertisements, exotic listings, rustic lists of marked properties, and rustic ad directories under Pilot Point-Aubrey Texas rent houses, apartment rentals in Pilot Point-Aubrey Texas, and Pilot Point-Aubrey Texas houses for rent.
Recognize and look up the neighborhood and handy Pilot Point-Aubrey Texas township.
Discover and distinguish homes for rent in Summerfield United States and Summerfield United States houses for rent.
|
|
