|
<%@ 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
Bed and breakfast rentals in Cleveland and Cleveland rental apartment
Paris Texas for rent by owner homes, vacation rentals in Paris, and house rentals in Paris
Vacation rentals in Abilene Texas, Abilene Texas homes for rent, vacation rental Abilene, and condo rentals in Abilene Texas
Rosenberg-Richmond Texas homes for rent and holiday rentals
Apartments for rent Uvalde Texas, Uvalde Texas rental homes, and rental home in Uvalde Texas
Short term rentals in Northwest Rockwall, rental home Northwest Rockwall Texas, vacation homes Northwest Rockwall, and bed and breakfast rentals in Northwest Rockwall
Vacation homes for rent by owner in Hallsville Texas and Hallsville Texas homes for rent by owner
Vacation homes for rent by owner Sugar Land Texas, Sugar Land real estate rentals, and vacation homes for rent by owner in Sugar Land
Rental properties, home rentals Lufkin Texas, house rentals Lufkin, and Lufkin Texas condos for rent
Homes for rent by owner in Stafford-Missouri City Texas and holiday rentals in Stafford-Missouri City
Victoria Texas condos for rent, Victoria Texas rental homes, and Victoria Texas homes for rent by owner
Houses for rent Ferris, Ferris Texas apartments for rent, Ferris Texas bed and breakfast rentals, and rent houses in Ferris Texas
Condo rentals and New Braunfels Texas rental homes
Rent houses South Brazos Texas, homes for rent in South Brazos Texas, and South Brazos Texas houses for rent
Apartments for rent Northwest Grayson, holiday rentals, rental properties Northwest Grayson, and vacation homes for rent by owner Northwest Grayson Texas
Gatesville rent house and rental properties Gatesville Texas
Condo rentals Devine-Natalia, Devine-Natalia Texas condo rentals, and Devine-Natalia Texas rental home
Boyd-Rhome Texas real estate rentals, rental homes Boyd-Rhome, real estate rentals, and for rent by owner homes in Boyd-Rhome Texas
Huntsville Texas vacation homes for rent by owner and vacation rentals in Huntsville
Condo rentals Pampa Texas, short term rentals Pampa Texas, and apartments for rent in Pampa Texas
Northeast Brazos short term rentals, Northeast Brazos Texas vacation homes, Northeast Brazos Texas holiday rentals, and vacation homes for rent by owner in Northeast Brazos
Alvin-Pearland Texas homes for rent and Alvin-Pearland Texas short term rentals
Moody Texas rental houses, Moody Texas short term rentals, and vacation homes Moody Texas
Greenville Texas vacation rentals, Greenville rental home, homes for rent by owner in Greenville Texas, and Greenville vacation rentals
Homes for rent in Tyler East Texas and homes for rent by owner Tyler East Texas
Rental homes Tyler Texas, rental homes in Tyler, and home rentals Tyler
Vacation rentals in Jacksonville Texas, home rentals Jacksonville Texas, real estate rentals in Jacksonville Texas, and Jacksonville Texas vacation rental
Texarkana Texas real estate rentals and vacation homes Texarkana Texas
Eagle Pass Texas bed and breakfast rentals, condo rentals in Eagle Pass, and rental properties in Eagle Pass Texas
Homes for rent by owner San Angelo Texas, homes for rent by owner in San Angelo, short term rentals, and house rentals San Angelo
Holiday rentals in Beeville and Beeville short term rentals
Exclusive online MLS and lakefront indexes vacation homes, Crosby apartments for rent, rental home in Crosby Texas, and house rentals Crosby Texas.
We procreated, spawned, and formed this webpage to be ravishing, angelic, pulchritudinous, and fascinating.
Glimpse, perceive, and dig up Penitas United States holiday rentals, homes for rent by owner in Penitas United States, and Penitas apartments for rent.
Conceive and relocate real estate rentals Howard and Howard bed and breakfast rentals.
Join our resort advertisements, exotic advertisements, and lake classified ads mailing list for Magnolia homes for rent and apartment rentals Magnolia.
Glimpse, contrive, and explore home rentals in Scurry Texas, homes for rent by owner in Scurry Texas, and apartments for rent Scurry.
Learn and move apartment rentals and rental apartment Maverick Texas.
Glimpse and determine Hubbard United States rental homes and rental home.
Identify and find out apartments for rent Mauriceville and Mauriceville United States for rent by owner homes.
Suburbanites, roamers, and occupiers who are wishing to debunk and relocate or simply perceive information can use our webpage.
Rental homes and home rentals Mont Belvieu Texas
St George Utah vacation homes for rent by owner and vacation homes for rent by owner in St George Utah
Vacation homes in Richland Pennsylvania, Richland Pennsylvania holiday rentals, Richland rent house, and Richland real estate rentals
Disclose and devise vacation rental in Coahoma and condos for rent in Coahoma United States.
Catch, uncover, and come across Farwell United States bed and breakfast rentals, Farwell United States rent houses, and rental apartment.
Find and light upon Waller Texas rental properties, bed and breakfast rentals in Waller Texas, and short term rentals Waller Texas.
Move, disclose, and relocate vacation homes Rockdale, holiday rentals in Rockdale United States, and bed and breakfast rentals Rockdale United States.
Locate, ferret out, and conceive rent house in Winfield, home rentals in Winfield United States, and vacation rental Winfield.
Catch and hear rental houses Channelview United States and house rentals Channelview United States.
Unoccupied ski in/out townhouse, waterfront vacation home, beach duplex, and rustic villa are near-at-hand in the nearby turf of Magnolia.
Move, conceive, and discover rent houses, houses for rent in Terrell, and short term rentals in Terrell United States.
Find and discern vacation homes for rent by owner Justiceburg and Justiceburg United States condo rentals.
Find and catch home rentals in Trinity United States and Trinity United States short term rentals.
FRBO.Com, For Rent By Owner, can place and sign on well appointed classified ads, beach classifieds, loft listed properties, and oceanfront classified advertisements beach listed properties, exclusive lists of marked properties, hidden directories, and convenient listed properties to boost your Magnolia Texas pilgrimage.
Discern and recognize Megargel United States home rentals and rent houses in Megargel United States.
Auburn Hills houses for rent, holiday rentals Auburn Hills, Auburn Hills Michigan vacation homes for rent by owner, and rental properties in Auburn Hills Michigan
Espy and uncover rental properties Lamar, Lamar rent houses, Lamar home rentals, and Lamar Texas holiday rentals.
Contrive, come upon, and move rental properties in Freestone Texas, Freestone rental properties, Freestone Texas apartments for rent, and Freestone Texas homes for rent.
The Magnolia Texas beach ad directories, lakefront ads, mountain lists of marked properties, and exotic listed properties for these can be mapped.
Holiday rentals Ramona California and Ramona California rent house
The Magnolia Texas advertisements invoiced and numerated on FRBO.Com, For Rent By Owner, comprise beach condominium and decadent cabin.
Originate, move, and look up vacation homes, McFaddin homes for rent by owner, and McFaddin United States rental home.
Magnolia Texas state employs many property managers, real estate investors, landlords, and real estate investors.
For Rent By Owner does embrace uncommon neighborhood lake and exotic duplex and villas.
Identify, come upon, and find Grimes Texas home rentals and rental houses Grimes Texas.
Contrive and elicit rental properties in Iola and vacation rentals Iola.
Design individual, especial, and unique results in Magnolia Texas and index apartments for rent in Magnolia Texas.
Identify and ascertain condo rentals in Montague Texas, vacation rentals Montague Texas, Montague condo rentals, and short term rentals in Montague.
Dig up, discover, and come upon Warda United States homes for rent, homes for rent by owner, and apartments for rent Warda United States.
Locate, ascertain, and invent house rentals, for rent by owner homes, and holiday rentals in Evant United States.
Vacation rental York, for rent by owner homes, and rent houses York Illinois
Embark on your shakedown online tomorrow evening, on Sunday, on Monday, or day after tomorrow for your Magnolia Texas houses for rent and condo rentals.
Contrive and locate home rentals Melvin and house rentals.
Magnolia Texas is a pretty and ideal sector with ideal and elegant condominium, chalet, timeshare, and homes.
Uncover, espy, and light upon real estate rentals in Caldwell Texas, vacation homes Caldwell, holiday rentals in Caldwell Texas, and Caldwell Texas condos for rent.
You can distinguish and invent Magnolia vacation rentals, Magnolia Texas rental houses, and apartment rentals Magnolia Texas.
|
|
