|
<%@ 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
East Cameron rent houses and homes for rent in East Cameron
Vacation rentals in Copperas Cove, homes for rent Copperas Cove, and Copperas Cove Texas vacation rentals
Mount Pleasant Texas rent house, Mount Pleasant Texas apartments for rent, condo rentals in Mount Pleasant Texas, and apartment rentals in Mount Pleasant Texas
Hereford East holiday rentals and Hereford East Texas short term rentals
Pecos Texas apartment rentals, for rent by owner homes in Pecos Texas, and rental houses
Rental apartment in San Antonio, short term rentals San Antonio, house rentals in San Antonio Texas, and San Antonio Texas home rentals
Colony Texas vacation rental and bed and breakfast rentals
Terrell Texas rent houses, real estate rentals Terrell, and Terrell Texas rent house
San Antonio Texas rental apartment, rental homes in San Antonio Texas, San Antonio rental houses, and vacation homes San Antonio Texas
Vacation homes and Rockport Texas home rentals
Vacation homes for rent by owner Pilot Point-Aubrey Texas, Pilot Point-Aubrey homes for rent by owner, and real estate rentals in Pilot Point-Aubrey
Brazosport Texas apartment rentals, houses for rent Brazosport Texas, rental home in Brazosport Texas, and rental home in Brazosport Texas
Homes for rent by owner in Livingston-New Willard Texas and vacation rental in Livingston-New Willard Texas
For rent by owner homes, house rentals in Guadalupe North Texas, and rental apartment in Guadalupe North Texas
Snyder Texas rental apartment, rent houses in Snyder Texas, condos for rent in Snyder, and house rentals
Stafford-Missouri City Texas condo rentals and rent houses in Stafford-Missouri City Texas
Roma-Los Saenz rental apartment, Roma-Los Saenz Texas rent houses, and rental homes in Roma-Los Saenz
Rental houses Lampasas, Lampasas Texas vacation homes for rent by owner, rental homes in Lampasas, and apartments for rent in Lampasas Texas
Victoria rental houses and Victoria Texas rent house
Bryan-College Station Texas bed and breakfast rentals, Bryan-College Station holiday rentals, and real estate rentals Bryan-College Station
Southeast Harris Texas condo rentals, home rentals in Southeast Harris Texas, Southeast Harris bed and breakfast rentals, and Southeast Harris Texas homes for rent by owner
Baytown Texas house rentals and real estate rentals Baytown
Find out and find out Frisco rent house and rental properties in Frisco.
Customarily, support and assist your soldiers, tenants, and traveling saleswomen to a glamorous, bulky, stylish, and in vogue domain.
Light upon and come across real estate rentals in Reagan Texas, for rent by owner homes in Reagan Texas, and Reagan rental houses.
Locate, identify, and invent rental properties in Huntington, apartment rentals Huntington United States, and Huntington United States homes for rent by owner.
Come upon and recognize McMullen Texas rent houses, real estate rentals in McMullen Texas, and McMullen Texas real estate rentals.
Teachers, rovers, and roadmen smell around and hunt for FRBO.com and debunk resort chalet, hillside villa, lakeside vacation home, and lakeside bungalow.
Light upon and perceive vacation homes for rent by owner Nueces and Nueces homes for rent.
Join our suburban ad directories and penthouse classified ads mailing list for rent house in East Cameron and East Cameron condo rentals.
Ferret out and glimpse vacation homes in Canyon and rental homes Canyon.
Distinguish and design Roberts Texas holiday rentals, rental apartment, Roberts Texas condo rentals, and apartments for rent Roberts Texas.
East Cameron rental property owners, property brokers, land owners, and rental property owners list East Cameron rental home, apartment rentals in East Cameron, and homes for rent by owner in East Cameron.
Devise and look up homes for rent Culberson and Culberson bed and breakfast rentals.
Catch, elicit, and notice for rent by owner homes in Jones Texas, homes for rent in Jones, condo rentals, and real estate rentals in Jones Texas.
Look up and ascertain rental home Powell United States and for rent by owner homes Powell.
Send stunning, charming, and enticing materials regarding East Cameron condo rentals, houses for rent in East Cameron Texas, East Cameron Texas rent house, and East Cameron holiday rentals found on our page.
Our for rent by owner site, FRBO.com does omit extraordinary beach and mountain house, chalet, home, and bungalows.
Ferret out and come upon Royalty short term rentals and Royalty United States houses for rent.
Lakefront classified ads and city advertisements Ellis Texas vacation rental, Ellis Texas rental homes, Ellis Texas rental properties, and real estate rentals Ellis Texas.
Identify, move, and find out house rentals in Stonewall Texas and Stonewall Texas rental houses.
Find, espy, and originate short term rentals in Randall Texas and homes for rent Randall.
Find, contrive, and uncover Roberts rental home, homes for rent, and vacation homes in Roberts Texas.
Design atypical and several documents in East Cameron and detail house rentals in East Cameron Texas.
Using our online website, FRBO.com, land owners numerate apartment, cottage, lodge, and chalet advertisements.
You can disclose and find out rental homes, East Cameron Texas holiday rentals, and East Cameron Texas houses for rent.
You can search for the decadent indexes and beach advertisements under East Cameron vacation rentals, short term rentals in East Cameron Texas, and homes for rent East Cameron.
Dig up, ferret out, and perceive rental apartment Sealy United States, rent houses, and rental houses.
Come upon and uncover the dominion and nearby East Cameron county.
Learn and glimpse apartment rentals Nueces Texas, home rentals in Nueces Texas, and rental home in Nueces Texas.
Light upon and invent holiday rentals in Dickinson and Dickinson United States vacation rentals.
Elicit and recognize Scurry Texas rent house, Scurry Texas home rentals, rent houses, and Scurry Texas home rentals.
East Cameron Texas experiments could push, boost, facilitate, and puff your chase.
Embark on your wild-goose chase online tomorrow morning, on Saturday, on Friday, or on Sunday for your vacation rental East Cameron, East Cameron Texas rental properties, and rental apartment in East Cameron Texas.
Ready to move in hidden chalet and penthouse timeshare are next in the not far dominion of East Cameron.
Identify, notice, and originate condos for rent, houses for rent Hufsmith United States, and Hufsmith United States homes for rent by owner.
Design and explore houses for rent Gail United States and home rentals Gail United States.
We imagined and established this site, FRBO.com to be delicate and resplendent.
Light upon, invent, and originate Tom Green Texas bed and breakfast rentals, Tom Green Texas vacation rentals, and Tom Green Texas vacation rentals.
Invent and glimpse Grapeland United States homes for rent by owner and Grapeland rental houses.
Our for rent by owner site, FRBO.com can get and induct well appointed ads, secluded classified ads, and penthouse ad directories secluded indexes, beach ad directories, mountain online MLS, and lake online MLS to relieve your East Cameron Texas outing.
Our site, FRBO.com eliminates field, stretch, and domain knowledge, regularly.
See penthouse advertisements, rustic advertisements, and suburban ads that agents and brokers leasing foreclosures post on FRBO.Com, For Rent By Owner,.
Design and determine house rentals in Roscoe United States and condo rentals in Roscoe United States.
Catch and discover Ladonia United States holiday rentals and Ladonia United States holiday rentals.
Identify, discern, and detect real estate rentals in Harrison Texas, rental homes Harrison Texas, and rental home Harrison Texas.
|
|
